package com.gdufe.order.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.gdufe.common.entity.OrderEntity;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.time.LocalDateTime;
import java.util.List;

/**
 * @author honghu
 * @email 3027708213@qq.com
 * @date 2023-10-28 16:07:06
 */
@Mapper
public interface OrderDao extends BaseMapper<OrderEntity> {

    @Select("select * from minimall_order.mall_order where status = #{orderStatus} and create_time < #{time}")
    List<OrderEntity> getListNotPay(Integer orderStatus, LocalDateTime time);
}
